﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SqlSugar;


namespace LogForParameter.Model
{
    ///<summary>
    ///科室代码/部门代码
    ///</summary>
    [SugarTable( "PUBLIC_DEPARTMENT", "wmblog_oracle")]
    public partial class PUBLIC_DEPARTMENT
    {
           public PUBLIC_DEPARTMENT()
           {
           }
           /// <summary>
           /// Desc:部门id
           /// Default:
           /// Nullable:False
           /// </summary>
           [SugarColumn(IsPrimaryKey=true)]
           public string DEPARTMENTID { get; set; }
           /// <summary>
           /// Desc:病区名称
           /// Default:
           /// Nullable:True
           /// </summary>
           public string DEPARTMENTNAME { get; set; }
           /// <summary>
           /// Desc:科室名称
           /// Default:
           /// Nullable:True
           /// </summary>
           public string WARDNAME { get; set; }
           /// <summary>
           /// Desc:上级部门名称
           /// Default:
           /// Nullable:True
           /// </summary>
           public string PARENTDEPARTMENTID { get; set; }
           /// <summary>
           /// Desc:拼音首字母
           /// Default:
           /// Nullable:True
           /// </summary>
           public string SPELL { get; set; }
           /// <summary>
           /// Desc:五笔码
           /// Default:
           /// Nullable:True
           /// </summary>
           public string COSTA { get; set; }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>
           public string TYPE { get; set; }
           /// <summary>
           /// Desc:排序码
           /// Default:
           /// Nullable:True
           /// </summary>
           public Single? SORT { get; set; }
           /// <summary>
           /// Desc:状态
           /// Default:
           /// Nullable:True
           /// </summary>
           public decimal? STATE { get; set; }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>
           public decimal? REPORT { get; set; }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>
           public decimal? CONSOLUTION { get; set; }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>
           public string CLASS { get; set; }
           /// <summary>
           /// Desc:
           /// Default:
           /// Nullable:True
           /// </summary>
           public string MODULARITEM { get; set; }
           /// <summary>
           /// Desc:中药发药药房
           /// Default:
           /// Nullable:True
           /// </summary>
           public short? HERBAL_PHARMACY { get; set; }
           /// <summary>
           /// Desc:西药发药药房
           /// Default:
           /// Nullable:True
           /// </summary>
           public short? MEDICINE_PHARMACY { get; set; }
           /// <summary>
           /// Desc:1住院 2门诊 3急诊(仅针对部门类型为临床的)
           /// Default:
           /// Nullable:True
           /// </summary>
           public bool INOUT_FLAG { get; set; }
           /// <summary>
           /// Desc:中成药发药药房
           /// Default:
           /// Nullable:True
           /// </summary>
           public short? CHINESE_PHARMACY { get; set; }
    }
    /// <summary>
    /// 部分类加导航属性实现子查询子部门
    /// </summary>
    public partial class PUBLIC_DEPARTMENT
    {
        [Navigate(NavigateType.OneToMany,nameof(DEPARTMENTID),nameof(PARENTDEPARTMENTID))]
        public List<PUBLIC_DEPARTMENT> PUBLIC_DEPARTMENTS { get; set; }
    }
}